{ "cells": [ { "cell_type": "markdown", "id": "b650d739", "metadata": {}, "source": [ "# Solscan API Tutorial" ] }, { "cell_type": "markdown", "id": "90d1e1be", "metadata": {}, "source": [ "This tutorial aims to be a quick guide to get you started using the Solscan API integrated into messari's python library." ] }, { "cell_type": "code", "execution_count": 2, "id": "4f68f0a5", "metadata": {}, "outputs": [], "source": [ "from messari.blockexplorers import Solscan\n", "ss = Solscan()" ] }, { "cell_type": "markdown", "id": "65789ffb", "metadata": {}, "source": [ "## API Structure\n", "The Solscan API Python client contains a number of functions that wrap some of Solscan's API endpoints. These include:\n", "\n", "Blocks\n", "\n", "* get_last_blocks\n", "* get_block_last_transactions\n", "* get_block\n", "\n", "Transactions\n", "\n", "* get_last_transactions\n", "* get_transaction\n", "\n", "Accounts\n", "\n", "* get_account_tokens\n", "* get_account_transactions\n", "* get_account_stake\n", "* get_account_spl_transactions\n", "* get_account_sol_transactions\n", "* get_account_export_transactions\n", "* get_account\n", "\n", "Tokens\n", "\n", "* get_token_holders\n", "* get_token_meta\n", "* get_token_list\n", "\n", "Markets\n", "\n", "* get_market_info\n", "\n", "Chains\n", "\n", "* get_chain_info\n", "\n", "Below are a few examples to showcase the functionality and types of data each function generates." ] }, { "cell_type": "markdown", "id": "86a88df1", "metadata": {}, "source": [ "## Blocks" ] }, { "cell_type": "markdown", "id": "9817299a", "metadata": {}, "source": [ "### get_last_blocks" ] }, { "cell_type": "markdown", "id": "b9e965ac", "metadata": {}, "source": [ "returns info for last num_blocks (default is 1, limit is 20)" ] }, { "cell_type": "code", "execution_count": 2, "id": "e8a14b29", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
result
blockHeightblockTimeblockhashparentSlotpreviousBlockhashfeeRewardsvalidatortransactionCountcodemessage
099400261.01.638813e+093A1bhWg9Vg6dqQoRos9WtQSb8ujfUK1xE9LVooWULhFW110340261.0PXmDCpr39WMXjEXnT41DVGHMrBhcKkokM7bSKas29z32295000.03zqJYiE5oAtm8XqNnG5n1Wd45STF7wmpsNRusGmQ5LWC905.0NaNNaN
199400260.01.638813e+09PXmDCpr39WMXjEXnT41DVGHMrBhcKkokM7bSKas29z3110340260.0DSHKVXkVWh3E4gXsaLsm7QMypmUB6dXk2wmVViZzUVt32870000.03zqJYiE5oAtm8XqNnG5n1Wd45STF7wmpsNRusGmQ5LWC1138.0NaNNaN
299400259.01.638813e+09DSHKVXkVWh3E4gXsaLsm7QMypmUB6dXk2wmVViZzUVt3110340259.06SeW4gNrMj5iMzADjeSHSPx7k7MvqP8DS6Xp6bYXiCW54095000.03zqJYiE5oAtm8XqNnG5n1Wd45STF7wmpsNRusGmQ5LWC1617.0NaNNaN
399400258.01.638813e+096SeW4gNrMj5iMzADjeSHSPx7k7MvqP8DS6Xp6bYXiCW5110340258.04WwSyAqGasr15YdHyezii4BVVnyHFen8Zp19HkfSe3kX1957500.09Ukj3PkyD3igEDJGt1QTj9ThzjK6hMiadQfa3gm7kjf1768.0NaNNaN
499400257.01.638813e+094WwSyAqGasr15YdHyezii4BVVnyHFen8Zp19HkfSe3kX110340257.0HHXabEZctn4jGMoGhJ76e6WBAb1CPfV5sXB1bofckkpf1815000.09Ukj3PkyD3igEDJGt1QTj9ThzjK6hMiadQfa3gm7kjf1706.0NaNNaN
\n", "
" ], "text/plain": [ " result \\\n", " blockHeight blockTime blockhash \n", "0 99400261.0 1.638813e+09 3A1bhWg9Vg6dqQoRos9WtQSb8ujfUK1xE9LVooWULhFW \n", "1 99400260.0 1.638813e+09 PXmDCpr39WMXjEXnT41DVGHMrBhcKkokM7bSKas29z3 \n", "2 99400259.0 1.638813e+09 DSHKVXkVWh3E4gXsaLsm7QMypmUB6dXk2wmVViZzUVt3 \n", "3 99400258.0 1.638813e+09 6SeW4gNrMj5iMzADjeSHSPx7k7MvqP8DS6Xp6bYXiCW5 \n", "4 99400257.0 1.638813e+09 4WwSyAqGasr15YdHyezii4BVVnyHFen8Zp19HkfSe3kX \n", "\n", " \\\n", " parentSlot previousBlockhash feeRewards \n", "0 110340261.0 PXmDCpr39WMXjEXnT41DVGHMrBhcKkokM7bSKas29z3 2295000.0 \n", "1 110340260.0 DSHKVXkVWh3E4gXsaLsm7QMypmUB6dXk2wmVViZzUVt3 2870000.0 \n", "2 110340259.0 6SeW4gNrMj5iMzADjeSHSPx7k7MvqP8DS6Xp6bYXiCW5 4095000.0 \n", "3 110340258.0 4WwSyAqGasr15YdHyezii4BVVnyHFen8Zp19HkfSe3kX 1957500.0 \n", "4 110340257.0 HHXabEZctn4jGMoGhJ76e6WBAb1CPfV5sXB1bofckkpf 1815000.0 \n", "\n", " \n", " validator transactionCount code message \n", "0 3zqJYiE5oAtm8XqNnG5n1Wd45STF7wmpsNRusGmQ5LWC 905.0 NaN NaN \n", "1 3zqJYiE5oAtm8XqNnG5n1Wd45STF7wmpsNRusGmQ5LWC 1138.0 NaN NaN \n", "2 3zqJYiE5oAtm8XqNnG5n1Wd45STF7wmpsNRusGmQ5LWC 1617.0 NaN NaN \n", "3 9Ukj3PkyD3igEDJGt1QTj9ThzjK6hMiadQfa3gm7kjf1 768.0 NaN NaN \n", "4 9Ukj3PkyD3igEDJGt1QTj9ThzjK6hMiadQfa3gm7kjf1 706.0 NaN NaN " ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "last_blocks = ss.get_last_blocks(num_blocks=10)\n", "last_blocks.head()" ] }, { "cell_type": "markdown", "id": "c300dc7b", "metadata": {}, "source": [ "### get_block_last_transactions" ] }, { "cell_type": "markdown", "id": "5aca33a6", "metadata": {}, "source": [ "get last num_transactions (default is 10) transactions of given block numbers" ] }, { "cell_type": "code", "execution_count": 19, "id": "86fd5f04", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
109452586...109452587
meta...metatransaction
errfeeinnerInstructionslogMessagespostBalancespostTokenBalancespreBalancespreTokenBalancesrewardsstatus...innerInstructionslogMessagespostBalancespostTokenBalancespreBalancespreTokenBalancesrewardsstatusmessagesignatures
0None5000[][Program Vote111111111111111111111111111111111...[7823553170, 24877594446, 143487360, 1169280, 1][][7823558170, 24877594446, 143487360, 1169280, 1][][]{'Ok': None}...[][Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497...[133789020000, 23942400, 1169280, 1141440][][133789025000, 23942400, 1169280, 1141440][][]{'Ok': None}{'accountKeys': [{'pubkey': 'AmmvowPnL2z1CVGR2...[5RZDigDYBPbEEZquFtdxoFojuxd6mXNR2ioinGCLFWryC...
1None5000[][Program Vote111111111111111111111111111111111...[157342449420, 526295101974, 143487360, 116928...[][157342454420, 526295101974, 143487360, 116928...[][]{'Ok': None}...[][Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497...[29112031780, 23942400, 1169280, 1141440][][29112036780, 23942400, 1169280, 1141440][][]{'Err': {'InstructionError': [0, 'InvalidArgum...{'accountKeys': [{'pubkey': 'Y2akr3bXHRsqyP1QJ...[4A13E9gc28KYUtk72MNKG82UecC7qGca45ki5TuXF75MC...
2None5000[][Program Vote111111111111111111111111111111111...[48148996950, 26858640, 143487360, 1169280, 1][][48149001950, 26858640, 143487360, 1169280, 1][][]{'Ok': None}...[][Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497...[42412955000, 23942400, 1169280, 1141440][][42412960000, 23942400, 1169280, 1141440][][]{'Err': {'InstructionError': [0, 'InvalidArgum...{'accountKeys': [{'pubkey': 'H8JEG2wjU2LnjXJUV...[4yhTuQ5sU85DcRdbxEyFbm9tz1GQoSZPNEiwfobiVw1Aq...
3None5000[][Program Vote111111111111111111111111111111111...[31289817916, 6088444438, 143487360, 1169280, 1][][31289822916, 6088444438, 143487360, 1169280, 1][][]{'Ok': None}...[][Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497...[98864590000, 23942400, 1169280, 1141440][][98864595000, 23942400, 1169280, 1141440][][]{'Err': {'InstructionError': [0, 'InvalidArgum...{'accountKeys': [{'pubkey': 'HekM1hBawXQu6wK6A...[48ZECs4cwUD69LNaTkPS3BAXbshMURxEnARLS1X1ES7hJ...
4None5000[][Program Vote111111111111111111111111111111111...[130881088161, 201128364143, 143487360, 116928...[][130881093161, 201128364143, 143487360, 116928...[][]{'Ok': None}...[][Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497...[29112026780, 23942400, 1169280, 1141440][][29112031780, 23942400, 1169280, 1141440][][]{'Err': {'InstructionError': [0, 'InvalidArgum...{'accountKeys': [{'pubkey': 'Y2akr3bXHRsqyP1QJ...[39egvPjtd31euZL2jdrzPBcwAnCx77PfaBVGUNDyAUn8D...
\n", "

5 rows × 24 columns

\n", "
" ], "text/plain": [ " 109452586 \\\n", " meta \n", " err fee innerInstructions \n", "0 None 5000 [] \n", "1 None 5000 [] \n", "2 None 5000 [] \n", "3 None 5000 [] \n", "4 None 5000 [] \n", "\n", " \\\n", " \n", " logMessages \n", "0 [Program Vote111111111111111111111111111111111... \n", "1 [Program Vote111111111111111111111111111111111... \n", "2 [Program Vote111111111111111111111111111111111... \n", "3 [Program Vote111111111111111111111111111111111... \n", "4 [Program Vote111111111111111111111111111111111... \n", "\n", " \\\n", " \n", " postBalances postTokenBalances \n", "0 [7823553170, 24877594446, 143487360, 1169280, 1] [] \n", "1 [157342449420, 526295101974, 143487360, 116928... [] \n", "2 [48148996950, 26858640, 143487360, 1169280, 1] [] \n", "3 [31289817916, 6088444438, 143487360, 1169280, 1] [] \n", "4 [130881088161, 201128364143, 143487360, 116928... [] \n", "\n", " \\\n", " \n", " preBalances preTokenBalances rewards \n", "0 [7823558170, 24877594446, 143487360, 1169280, 1] [] [] \n", "1 [157342454420, 526295101974, 143487360, 116928... [] [] \n", "2 [48149001950, 26858640, 143487360, 1169280, 1] [] [] \n", "3 [31289822916, 6088444438, 143487360, 1169280, 1] [] [] \n", "4 [130881093161, 201128364143, 143487360, 116928... [] [] \n", "\n", " ... 109452587 \\\n", " ... meta \n", " status ... innerInstructions \n", "0 {'Ok': None} ... [] \n", "1 {'Ok': None} ... [] \n", "2 {'Ok': None} ... [] \n", "3 {'Ok': None} ... [] \n", "4 {'Ok': None} ... [] \n", "\n", " \\\n", " \n", " logMessages \n", "0 [Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497... \n", "1 [Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497... \n", "2 [Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497... \n", "3 [Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497... \n", "4 [Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497... \n", "\n", " \\\n", " \n", " postBalances postTokenBalances \n", "0 [133789020000, 23942400, 1169280, 1141440] [] \n", "1 [29112031780, 23942400, 1169280, 1141440] [] \n", "2 [42412955000, 23942400, 1169280, 1141440] [] \n", "3 [98864590000, 23942400, 1169280, 1141440] [] \n", "4 [29112026780, 23942400, 1169280, 1141440] [] \n", "\n", " \\\n", " \n", " preBalances preTokenBalances rewards \n", "0 [133789025000, 23942400, 1169280, 1141440] [] [] \n", "1 [29112036780, 23942400, 1169280, 1141440] [] [] \n", "2 [42412960000, 23942400, 1169280, 1141440] [] [] \n", "3 [98864595000, 23942400, 1169280, 1141440] [] [] \n", "4 [29112031780, 23942400, 1169280, 1141440] [] [] \n", "\n", " \\\n", " \n", " status \n", "0 {'Ok': None} \n", "1 {'Err': {'InstructionError': [0, 'InvalidArgum... \n", "2 {'Err': {'InstructionError': [0, 'InvalidArgum... \n", "3 {'Err': {'InstructionError': [0, 'InvalidArgum... \n", "4 {'Err': {'InstructionError': [0, 'InvalidArgum... \n", "\n", " \\\n", " transaction \n", " message \n", "0 {'accountKeys': [{'pubkey': 'AmmvowPnL2z1CVGR2... \n", "1 {'accountKeys': [{'pubkey': 'Y2akr3bXHRsqyP1QJ... \n", "2 {'accountKeys': [{'pubkey': 'H8JEG2wjU2LnjXJUV... \n", "3 {'accountKeys': [{'pubkey': 'HekM1hBawXQu6wK6A... \n", "4 {'accountKeys': [{'pubkey': 'Y2akr3bXHRsqyP1QJ... \n", "\n", " \n", " \n", " signatures \n", "0 [5RZDigDYBPbEEZquFtdxoFojuxd6mXNR2ioinGCLFWryC... \n", "1 [4A13E9gc28KYUtk72MNKG82UecC7qGca45ki5TuXF75MC... \n", "2 [4yhTuQ5sU85DcRdbxEyFbm9tz1GQoSZPNEiwfobiVw1Aq... \n", "3 [48ZECs4cwUD69LNaTkPS3BAXbshMURxEnARLS1X1ES7hJ... \n", "4 [39egvPjtd31euZL2jdrzPBcwAnCx77PfaBVGUNDyAUn8D... \n", "\n", "[5 rows x 24 columns]" ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "blocks = ['109452586', '109452587']\n", "block_last_transactions = ss.get_block_last_transactions(blocks, num_transactions=7)\n", "block_last_transactions.head()" ] }, { "cell_type": "markdown", "id": "82d9d711", "metadata": {}, "source": [ "### get_block" ] }, { "cell_type": "markdown", "id": "1e036a6c", "metadata": {}, "source": [ "Return information of given block(s)" ] }, { "cell_type": "code", "execution_count": 4, "id": "5d8be762", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
109452586109452587
blockHeight9859147698591477
blockTime16382950851638295085
blockhashGCTLNg2XZDzKgEmwiE8mRDTrjJEw9DC2nbo6Y73miHRLsMUtedNEJGKZWTWoPUMaNfzKcYpm884wRJN6LHTPYSL
feeRewards28150004945000
parentSlot109452585109452586
previousBlockhash2iosCGrQ6CthviS8dDdJzqhULH1AvBTyDG3xspqnvfMDGCTLNg2XZDzKgEmwiE8mRDTrjJEw9DC2nbo6Y73miHRL
transactionCount11121961
validator3B2mGaZoFwzAnWCoZ4EAKdps4FbYbDKQ48jo8u1XWynU3B2mGaZoFwzAnWCoZ4EAKdps4FbYbDKQ48jo8u1XWynU
\n", "
" ], "text/plain": [ " 109452586 \\\n", "blockHeight 98591476 \n", "blockTime 1638295085 \n", "blockhash GCTLNg2XZDzKgEmwiE8mRDTrjJEw9DC2nbo6Y73miHRL \n", "feeRewards 2815000 \n", "parentSlot 109452585 \n", "previousBlockhash 2iosCGrQ6CthviS8dDdJzqhULH1AvBTyDG3xspqnvfMD \n", "transactionCount 1112 \n", "validator 3B2mGaZoFwzAnWCoZ4EAKdps4FbYbDKQ48jo8u1XWynU \n", "\n", " 109452587 \n", "blockHeight 98591477 \n", "blockTime 1638295085 \n", "blockhash sMUtedNEJGKZWTWoPUMaNfzKcYpm884wRJN6LHTPYSL \n", "feeRewards 4945000 \n", "parentSlot 109452586 \n", "previousBlockhash GCTLNg2XZDzKgEmwiE8mRDTrjJEw9DC2nbo6Y73miHRL \n", "transactionCount 1961 \n", "validator 3B2mGaZoFwzAnWCoZ4EAKdps4FbYbDKQ48jo8u1XWynU " ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "blocks = ['109452586', '109452587']\n", "blocks_info = ss.get_block(blocks)\n", "blocks_info" ] }, { "cell_type": "markdown", "id": "50dc9fc4", "metadata": {}, "source": [ "## Transactions" ] }, { "cell_type": "markdown", "id": "6c16199e", "metadata": {}, "source": [ "### get_last_transactions" ] }, { "cell_type": "markdown", "id": "8ce969b5", "metadata": {}, "source": [ "Return last num_transactions (default 10, limit 20) transactions" ] }, { "cell_type": "code", "execution_count": 5, "id": "4d1d8ebc", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
metatransaction
errfeeinnerInstructionslogMessagespostBalancespostTokenBalancespreBalancespreTokenBalancesrewardsstatusmessagesignatures
0None5000[][Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497...[32792760000, 23942400, 1169280, 1141440][][32792765000, 23942400, 1169280, 1141440][][]{'Ok': None}{'accountKeys': [{'pubkey': 'HfeFy4G9r77iyeXdb...[25kpgb5QtW84khrHs8gPrHub6iYt7MAcFst39CMS2A9wt...
1None5000[][Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497...[14277730000, 23942400, 1169280, 1141440][][14277735000, 23942400, 1169280, 1141440][][]{'Ok': None}{'accountKeys': [{'pubkey': 'FZsgu4Gv9fn1iUm5v...[24MRofZ3YmbDhedDAWmZ8T7hwmg13hKA89PGFGJZW9rpb...
2{'InstructionError': [0, 'InvalidArgument']}5000[][Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497...[24959720000, 23942400, 1169280, 1141440][][24959725000, 23942400, 1169280, 1141440][][]{'Err': {'InstructionError': [0, 'InvalidArgum...{'accountKeys': [{'pubkey': '7Sur3cy2efJGv8Qom...[5D1AK1nFn63n144E4C6tUWJ4SidPPtRw9cXNtVZ7wuryu...
3{'InstructionError': [0, 'InvalidArgument']}5000[][Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497...[24452780000, 23942400, 1169280, 1141440][][24452785000, 23942400, 1169280, 1141440][][]{'Err': {'InstructionError': [0, 'InvalidArgum...{'accountKeys': [{'pubkey': '26LYr2NRPprQ7aq6H...[51tfsaXqzfiuYPNxtHszgG41xz1czLyQUBqaubTp1qhMe...
4None5000[][Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497...[24452775000, 24042400, 1169280, 1141440][][24452780000, 24042400, 1169280, 1141440][][]{'Ok': None}{'accountKeys': [{'pubkey': '26LYr2NRPprQ7aq6H...[5DQb2dinXCyq1HDtxb9fGMvgPB49rTrCNwRYSR36Hu5hh...
\n", "
" ], "text/plain": [ " meta \\\n", " err fee innerInstructions \n", "0 None 5000 [] \n", "1 None 5000 [] \n", "2 {'InstructionError': [0, 'InvalidArgument']} 5000 [] \n", "3 {'InstructionError': [0, 'InvalidArgument']} 5000 [] \n", "4 None 5000 [] \n", "\n", " \\\n", " logMessages \n", "0 [Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497... \n", "1 [Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497... \n", "2 [Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497... \n", "3 [Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497... \n", "4 [Program FsJ3A3u2vn5cTVofAjvy6y5kwABJAqYWpe497... \n", "\n", " \\\n", " postBalances postTokenBalances \n", "0 [32792760000, 23942400, 1169280, 1141440] [] \n", "1 [14277730000, 23942400, 1169280, 1141440] [] \n", "2 [24959720000, 23942400, 1169280, 1141440] [] \n", "3 [24452780000, 23942400, 1169280, 1141440] [] \n", "4 [24452775000, 24042400, 1169280, 1141440] [] \n", "\n", " \\\n", " preBalances preTokenBalances rewards \n", "0 [32792765000, 23942400, 1169280, 1141440] [] [] \n", "1 [14277735000, 23942400, 1169280, 1141440] [] [] \n", "2 [24959725000, 23942400, 1169280, 1141440] [] [] \n", "3 [24452785000, 23942400, 1169280, 1141440] [] [] \n", "4 [24452780000, 24042400, 1169280, 1141440] [] [] \n", "\n", " \\\n", " status \n", "0 {'Ok': None} \n", "1 {'Ok': None} \n", "2 {'Err': {'InstructionError': [0, 'InvalidArgum... \n", "3 {'Err': {'InstructionError': [0, 'InvalidArgum... \n", "4 {'Ok': None} \n", "\n", " transaction \\\n", " message \n", "0 {'accountKeys': [{'pubkey': 'HfeFy4G9r77iyeXdb... \n", "1 {'accountKeys': [{'pubkey': 'FZsgu4Gv9fn1iUm5v... \n", "2 {'accountKeys': [{'pubkey': '7Sur3cy2efJGv8Qom... \n", "3 {'accountKeys': [{'pubkey': '26LYr2NRPprQ7aq6H... \n", "4 {'accountKeys': [{'pubkey': '26LYr2NRPprQ7aq6H... \n", "\n", " \n", " signatures \n", "0 [25kpgb5QtW84khrHs8gPrHub6iYt7MAcFst39CMS2A9wt... \n", "1 [24MRofZ3YmbDhedDAWmZ8T7hwmg13hKA89PGFGJZW9rpb... \n", "2 [5D1AK1nFn63n144E4C6tUWJ4SidPPtRw9cXNtVZ7wuryu... \n", "3 [51tfsaXqzfiuYPNxtHszgG41xz1czLyQUBqaubTp1qhMe... \n", "4 [5DQb2dinXCyq1HDtxb9fGMvgPB49rTrCNwRYSR36Hu5hh... " ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "last_transactions = ss.get_last_transactions(num_transactions=20)\n", "last_transactions.head()" ] }, { "cell_type": "markdown", "id": "e451eca9", "metadata": {}, "source": [ "### get_transaction" ] }, { "cell_type": "markdown", "id": "e81cc337", "metadata": {}, "source": [ "Return information of given transaction signature(s)" ] }, { "cell_type": "code", "execution_count": 6, "id": "7e2dec25", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
T4ipYTjKUqHQpfuA8ZM5E4iJag9kX9nGhjbY974oq2ucyYRL6eWhqTjtmk3cqfqTSu8Qdce33vzKQd7bWEX3H215hJhu4RYQLZF3zBwTUzu6vbvt6kX71uoFTTdx6NurkESEeQsjTJNut6FzSjgBqGe8j9V4dDo2VFssbRGiwbachom
blockTime16345372051637774890
slot102135694108509877
txHashT4ipYTjKUqHQpfuA8ZM5E4iJag9kX9nGhjbY974oq2ucyY...5hJhu4RYQLZF3zBwTUzu6vbvt6kX71uoFTTdx6NurkESEe...
fee100005000
statusSuccessSuccess
lamport00
signer[BE3G2F5jKygsSNbPFKHHTxvKpuFXSumASeGweLcei6G3,...[Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ]
logMessage[Program 4kCccBVdQpsonm2jL2TRV1noMdarsWR2mhwwk...[Program 9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9...
inputAccount[{'account': 'BE3G2F5jKygsSNbPFKHHTxvKpuFXSumA...[{'account': 'Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Ut...
recentBlockhash6UzkdSfhm6UwXnFPWShj14Kn3TVjmYC1SS9LyXa86zLTChAnYUveHuqdNF41b9vB7vZb9Ca7JgLEPtF1GNbyjEMd
innerInstructions[{'index': 0, 'parsedInstructions': [{'program...[]
tokenBalanes[][]
parsedInstruction[{'programId': '4kCccBVdQpsonm2jL2TRV1noMdarsW...[{'programId': '9xQeWvG816bUx9EPjHmaT23yvVM2ZW...
confirmationsNoneNone
tokenTransfers[][]
solTransfers[][]
serumTransactions[][{'cancelOrder': {'programId': '9xQeWvG816bUx9...
raydiumTransactions[][]
unknownTransfers[{'programId': '4kCccBVdQpsonm2jL2TRV1noMdarsW...[]
\n", "
" ], "text/plain": [ " T4ipYTjKUqHQpfuA8ZM5E4iJag9kX9nGhjbY974oq2ucyYRL6eWhqTjtmk3cqfqTSu8Qdce33vzKQd7bWEX3H21 \\\n", "blockTime 1634537205 \n", "slot 102135694 \n", "txHash T4ipYTjKUqHQpfuA8ZM5E4iJag9kX9nGhjbY974oq2ucyY... \n", "fee 10000 \n", "status Success \n", "lamport 0 \n", "signer [BE3G2F5jKygsSNbPFKHHTxvKpuFXSumASeGweLcei6G3,... \n", "logMessage [Program 4kCccBVdQpsonm2jL2TRV1noMdarsWR2mhwwk... \n", "inputAccount [{'account': 'BE3G2F5jKygsSNbPFKHHTxvKpuFXSumA... \n", "recentBlockhash 6UzkdSfhm6UwXnFPWShj14Kn3TVjmYC1SS9LyXa86zLT \n", "innerInstructions [{'index': 0, 'parsedInstructions': [{'program... \n", "tokenBalanes [] \n", "parsedInstruction [{'programId': '4kCccBVdQpsonm2jL2TRV1noMdarsW... \n", "confirmations None \n", "tokenTransfers [] \n", "solTransfers [] \n", "serumTransactions [] \n", "raydiumTransactions [] \n", "unknownTransfers [{'programId': '4kCccBVdQpsonm2jL2TRV1noMdarsW... \n", "\n", " 5hJhu4RYQLZF3zBwTUzu6vbvt6kX71uoFTTdx6NurkESEeQsjTJNut6FzSjgBqGe8j9V4dDo2VFssbRGiwbachom \n", "blockTime 1637774890 \n", "slot 108509877 \n", "txHash 5hJhu4RYQLZF3zBwTUzu6vbvt6kX71uoFTTdx6NurkESEe... \n", "fee 5000 \n", "status Success \n", "lamport 0 \n", "signer [Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ] \n", "logMessage [Program 9xQeWvG816bUx9EPjHmaT23yvVM2ZWbrrpZb9... \n", "inputAccount [{'account': 'Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Ut... \n", "recentBlockhash ChAnYUveHuqdNF41b9vB7vZb9Ca7JgLEPtF1GNbyjEMd \n", "innerInstructions [] \n", "tokenBalanes [] \n", "parsedInstruction [{'programId': '9xQeWvG816bUx9EPjHmaT23yvVM2ZW... \n", "confirmations None \n", "tokenTransfers [] \n", "solTransfers [] \n", "serumTransactions [{'cancelOrder': {'programId': '9xQeWvG816bUx9... \n", "raydiumTransactions [] \n", "unknownTransfers [] " ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "transactions=['T4ipYTjKUqHQpfuA8ZM5E4iJag9kX9nGhjbY974oq2ucyYRL6eWhqTjtmk3cqfqTSu8Qdce33vzKQd7bWEX3H21', '5hJhu4RYQLZF3zBwTUzu6vbvt6kX71uoFTTdx6NurkESEeQsjTJNut6FzSjgBqGe8j9V4dDo2VFssbRGiwbachom']\n", "transactions_info = ss.get_transaction(transactions)\n", "transactions_info" ] }, { "cell_type": "markdown", "id": "71a16c77", "metadata": {}, "source": [ "## Accounts" ] }, { "cell_type": "markdown", "id": "712683e0", "metadata": {}, "source": [ "### get_account_tokens" ] }, { "cell_type": "markdown", "id": "47cef0af", "metadata": {}, "source": [ "Return token balances of the given account(s)" ] }, { "cell_type": "code", "execution_count": 7, "id": "fd9375b2", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS
tokenAddresstokenAmounttokenAccounttokenNametokenIconrentEpochlamportstokenSymbolpriceUsdttokenAddresstokenAmounttokenAccounttokenNametokenIconrentEpochlamportstokenSymbolpriceUsdt
0KNVfdSJyq1pRQk9AKKv1g5uyGuk6wpm4WG16Bjuwdma{'amount': '0', 'decimals': 9, 'uiAmount': 0, ...8w3DXCuLfmncbscY2ZPHSFm7RQ6qpFTv7ZQTeSkrHScUSaber Wrapped Ether (Wormhole) (9 decimals)https://raw.githubusercontent.com/solana-labs/...2542039280swhETH-94175.930000cUSDDDBZRhpDW7eyUUPMuw6u1SiMnzu6i7movwf5jxk{'amount': '0', 'decimals': 9, 'uiAmount': 0, ...FR5t12DKJGeYkChogSciyHXGZTAdpWgc2ZdjX1SsVHm2Saber acUSD-USDC LPhttps://raw.githubusercontent.com/solana-labs/...254.02039280.0acUSD-USDCNaN
1PoRTjZMPXb9T7dyU7tpLEZRQj7e6ssfAE62j2oQuc6y{'amount': '10518756', 'decimals': 6, 'uiAmoun...4E4wTBurw6jguirauunPuGciqxtUTUNecgpseUUt1L8WPort Finance Tokenhttps://raw.githubusercontent.com/solana-labs/...2552039280PORT2.190000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So{'amount': '0', 'decimals': 9, 'uiAmount': 0, ...F68t8jUTheFRPJ3gcfxw5E4q9fnadoAHngDCR18DbDv1Marinade staked SOL (mSOL)https://raw.githubusercontent.com/solana-labs/...254.02039280.0mSOL192.35
27vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs{'amount': '0', 'decimals': 8, 'uiAmount': 0, ...2uMiF9vPEogw9GiZa9UvPFxffoJpSUF6zKmWwKKjm2D3Wrapped Ether (Wormhole)https://raw.githubusercontent.com/solana-labs/...2552039280weWETH4179.280000EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v{'amount': '0', 'decimals': 6, 'uiAmount': 0, ...2Rsg7Geqa9zH4WU85SywgVu9wGaRe7XM7TpY3goT9BUmUSD Coinhttps://raw.githubusercontent.com/solana-labs/...255.02039280.0USDC1.00
3ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx{'amount': '0', 'decimals': 8, 'uiAmount': 0, ...7UQsVoVHrrkay8uGVm9rXbtAJfdgjjE1NSdVQs1KC1BBStar Atlashttps://raw.githubusercontent.com/solana-labs/...2552039280ATLAS0.1213827nzf4r8psSNTN6smb5Dw3rHMwMoc7y6auhbwZYUMkj6B{'amount': '0', 'decimals': 0, 'uiAmount': 0, ...AmSVeU2A62z42JvF375kpGTHMonb4Q6DuBcfWhCv3K6v254.02039280.0NaNNaN
4FTT9rBBrYwcHam4qLvkzzzhrsihYMbZ3k6wJbdoahxAt{'amount': '0', 'decimals': 9, 'uiAmount': 0, ...CWhrA3kVqd3uqC1YPF1bh1tSfUNH2VUNBsUuicttkt8DSaber Wrapped Wrapped FTT (Sollet) (9 decimals)https://raw.githubusercontent.com/solana-labs/...2542039280sFTT-941.9200008Yv9Jz4z7BUHP68dz8E8m3tMe6NKgpMUKn8KVqrPA6Fr{'amount': '0', 'decimals': 9, 'uiAmount': 0, ...CkJgVxAmg4Dri4Q3ifEjudXTBPmMfGPEmJuoY2ZXUdYtWrapped USDC (Allbridge from Avalanche)https://raw.githubusercontent.com/solana-labs/...254.02039280.0aaUSDC1.00
\n", "
" ], "text/plain": [ " Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ \\\n", " tokenAddress \n", "0 KNVfdSJyq1pRQk9AKKv1g5uyGuk6wpm4WG16Bjuwdma \n", "1 PoRTjZMPXb9T7dyU7tpLEZRQj7e6ssfAE62j2oQuc6y \n", "2 7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs \n", "3 ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx \n", "4 FTT9rBBrYwcHam4qLvkzzzhrsihYMbZ3k6wJbdoahxAt \n", "\n", " \\\n", " tokenAmount \n", "0 {'amount': '0', 'decimals': 9, 'uiAmount': 0, ... \n", "1 {'amount': '10518756', 'decimals': 6, 'uiAmoun... \n", "2 {'amount': '0', 'decimals': 8, 'uiAmount': 0, ... \n", "3 {'amount': '0', 'decimals': 8, 'uiAmount': 0, ... \n", "4 {'amount': '0', 'decimals': 9, 'uiAmount': 0, ... \n", "\n", " \\\n", " tokenAccount \n", "0 8w3DXCuLfmncbscY2ZPHSFm7RQ6qpFTv7ZQTeSkrHScU \n", "1 4E4wTBurw6jguirauunPuGciqxtUTUNecgpseUUt1L8W \n", "2 2uMiF9vPEogw9GiZa9UvPFxffoJpSUF6zKmWwKKjm2D3 \n", "3 7UQsVoVHrrkay8uGVm9rXbtAJfdgjjE1NSdVQs1KC1BB \n", "4 CWhrA3kVqd3uqC1YPF1bh1tSfUNH2VUNBsUuicttkt8D \n", "\n", " \\\n", " tokenName \n", "0 Saber Wrapped Ether (Wormhole) (9 decimals) \n", "1 Port Finance Token \n", "2 Wrapped Ether (Wormhole) \n", "3 Star Atlas \n", "4 Saber Wrapped Wrapped FTT (Sollet) (9 decimals) \n", "\n", " \\\n", " tokenIcon rentEpoch lamports \n", "0 https://raw.githubusercontent.com/solana-labs/... 254 2039280 \n", "1 https://raw.githubusercontent.com/solana-labs/... 255 2039280 \n", "2 https://raw.githubusercontent.com/solana-labs/... 255 2039280 \n", "3 https://raw.githubusercontent.com/solana-labs/... 255 2039280 \n", "4 https://raw.githubusercontent.com/solana-labs/... 254 2039280 \n", "\n", " 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS \\\n", " tokenSymbol priceUsdt tokenAddress \n", "0 swhETH-9 4175.930000 cUSDDDBZRhpDW7eyUUPMuw6u1SiMnzu6i7movwf5jxk \n", "1 PORT 2.190000 mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So \n", "2 weWETH 4179.280000 EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v \n", "3 ATLAS 0.121382 7nzf4r8psSNTN6smb5Dw3rHMwMoc7y6auhbwZYUMkj6B \n", "4 sFTT-9 41.920000 8Yv9Jz4z7BUHP68dz8E8m3tMe6NKgpMUKn8KVqrPA6Fr \n", "\n", " \\\n", " tokenAmount \n", "0 {'amount': '0', 'decimals': 9, 'uiAmount': 0, ... \n", "1 {'amount': '0', 'decimals': 9, 'uiAmount': 0, ... \n", "2 {'amount': '0', 'decimals': 6, 'uiAmount': 0, ... \n", "3 {'amount': '0', 'decimals': 0, 'uiAmount': 0, ... \n", "4 {'amount': '0', 'decimals': 9, 'uiAmount': 0, ... \n", "\n", " \\\n", " tokenAccount \n", "0 FR5t12DKJGeYkChogSciyHXGZTAdpWgc2ZdjX1SsVHm2 \n", "1 F68t8jUTheFRPJ3gcfxw5E4q9fnadoAHngDCR18DbDv1 \n", "2 2Rsg7Geqa9zH4WU85SywgVu9wGaRe7XM7TpY3goT9BUm \n", "3 AmSVeU2A62z42JvF375kpGTHMonb4Q6DuBcfWhCv3K6v \n", "4 CkJgVxAmg4Dri4Q3ifEjudXTBPmMfGPEmJuoY2ZXUdYt \n", "\n", " \\\n", " tokenName \n", "0 Saber acUSD-USDC LP \n", "1 Marinade staked SOL (mSOL) \n", "2 USD Coin \n", "3 \n", "4 Wrapped USDC (Allbridge from Avalanche) \n", "\n", " \\\n", " tokenIcon rentEpoch lamports \n", "0 https://raw.githubusercontent.com/solana-labs/... 254.0 2039280.0 \n", "1 https://raw.githubusercontent.com/solana-labs/... 254.0 2039280.0 \n", "2 https://raw.githubusercontent.com/solana-labs/... 255.0 2039280.0 \n", "3 254.0 2039280.0 \n", "4 https://raw.githubusercontent.com/solana-labs/... 254.0 2039280.0 \n", "\n", " \n", " tokenSymbol priceUsdt \n", "0 acUSD-USDC NaN \n", "1 mSOL 192.35 \n", "2 USDC 1.00 \n", "3 NaN NaN \n", "4 aaUSDC 1.00 " ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "accounts = ['Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ', '7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS']\n", "account_tokens = ss.get_account_tokens(accounts)\n", "account_tokens.head()" ] }, { "cell_type": "markdown", "id": "cd642db0", "metadata": {}, "source": [ "### get_account_transactions" ] }, { "cell_type": "markdown", "id": "408d559b", "metadata": {}, "source": [ "Return DataFrame of transactions of the given account(s)" ] }, { "cell_type": "code", "execution_count": 8, "id": "84ca501c", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
5FCSMognWSsNGjmYK9D387Zz79catdwEakdNtGf2UAJS
blockTimeslottxHashfeestatuslamportsignerparsedInstructionincludeSPLTransfer
01635825035104758613nqskrb6aunaGEtsU1PRjtNYU1mL4mCMZrpwzFd8bQghzDU...5000Success0[8mBkEdWR1CAS9Hy9UXB2GpPe6a5HCjy5Lfo2EZ23adnc][{'programId': 'ATokenGPvbdGVxr1b2hvZbsiqW5xWH...NaN
116353562441038219415pEs9Ddeh4DknHnu5szqYDoJcgFeYX2c2ttUGQCj2HUcua...15000Success0[HzrMJkkN5jvD98focyivbjasDmPwPY3AkuB9aG1uAzbH,...[{'programId': '111111111111111111111111111111...True
2163535622810382191834v3TqjYx5LgBeRYz9KavyuMgHfLvzaqAsNKdUG9AQrBjo...5000Success0[HzrMJkkN5jvD98focyivbjasDmPwPY3AkuB9aG1uAzbH][{'programId': 'A7p8451ktDCHq5yYaHczeLMYsjRsAk...NaN
316347825871026540645UocGkDeCTSf6VzVPcockSykdLa6DA7pi5vhcQpXVQfTej...15000Success0[HzrMJkkN5jvD98focyivbjasDmPwPY3AkuB9aG1uAzbH,...[{'programId': '111111111111111111111111111111...True
41632321489978143752TVkmHKhkkTsajp1bbJbAPnpnXZZT8u88WWsczbGiN8s2j...5000Success0[HzrMJkkN5jvD98focyivbjasDmPwPY3AkuB9aG1uAzbH][{'programId': 'A7p8451ktDCHq5yYaHczeLMYsjRsAk...NaN
51632267935977118132Lfe7Q8MuGNixJzJs7eQaArV8AMYArFXi6h6uiWkPb2SpL...15000Success0[HzrMJkkN5jvD98focyivbjasDmPwPY3AkuB9aG1uAzbH,...[{'programId': '111111111111111111111111111111...True
61632202237975873472nPNG8Eesat9wAwo9vrZy5bfYURo9dR41g3WkFhJdf5vR4...5000Success0[HzrMJkkN5jvD98focyivbjasDmPwPY3AkuB9aG1uAzbH][{'programId': 'ATokenGPvbdGVxr1b2hvZbsiqW5xWH...NaN
71632191828975668692hKZiz4uzc7nnDu5dn9F3a56Yp8vv9ASwSSHR5RYZmGBCo...15000Success0[AjJ64QbB7XnrEdC1Vroh2uiU9yjEds2HjoWSsxarYV7g,...[{'programId': '111111111111111111111111111111...True
81632191767975667535MvydpMqfS6BwjxUMptrNdqd84SWkAcK4edvbp1qNMrZ4D...5000Success0[AjJ64QbB7XnrEdC1Vroh2uiU9yjEds2HjoWSsxarYV7g][{'programId': 'A7p8451ktDCHq5yYaHczeLMYsjRsAk...NaN
916321907639756479127iwr5yX4jGVBaQyMrYC37X3RdBc5k7g3wBR2xg3H4zT3v...15000Success0[AjJ64QbB7XnrEdC1Vroh2uiU9yjEds2HjoWSsxarYV7g,...[{'programId': '111111111111111111111111111111...True
\n", "
" ], "text/plain": [ " 5FCSMognWSsNGjmYK9D387Zz79catdwEakdNtGf2UAJS \\\n", " blockTime slot \n", "0 1635825035 104758613 \n", "1 1635356244 103821941 \n", "2 1635356228 103821918 \n", "3 1634782587 102654064 \n", "4 1632321489 97814375 \n", "5 1632267935 97711813 \n", "6 1632202237 97587347 \n", "7 1632191828 97566869 \n", "8 1632191767 97566753 \n", "9 1632190763 97564791 \n", "\n", " \\\n", " txHash fee status lamport \n", "0 nqskrb6aunaGEtsU1PRjtNYU1mL4mCMZrpwzFd8bQghzDU... 5000 Success 0 \n", "1 5pEs9Ddeh4DknHnu5szqYDoJcgFeYX2c2ttUGQCj2HUcua... 15000 Success 0 \n", "2 34v3TqjYx5LgBeRYz9KavyuMgHfLvzaqAsNKdUG9AQrBjo... 5000 Success 0 \n", "3 5UocGkDeCTSf6VzVPcockSykdLa6DA7pi5vhcQpXVQfTej... 15000 Success 0 \n", "4 2TVkmHKhkkTsajp1bbJbAPnpnXZZT8u88WWsczbGiN8s2j... 5000 Success 0 \n", "5 2Lfe7Q8MuGNixJzJs7eQaArV8AMYArFXi6h6uiWkPb2SpL... 15000 Success 0 \n", "6 2nPNG8Eesat9wAwo9vrZy5bfYURo9dR41g3WkFhJdf5vR4... 5000 Success 0 \n", "7 2hKZiz4uzc7nnDu5dn9F3a56Yp8vv9ASwSSHR5RYZmGBCo... 15000 Success 0 \n", "8 5MvydpMqfS6BwjxUMptrNdqd84SWkAcK4edvbp1qNMrZ4D... 5000 Success 0 \n", "9 27iwr5yX4jGVBaQyMrYC37X3RdBc5k7g3wBR2xg3H4zT3v... 15000 Success 0 \n", "\n", " \\\n", " signer \n", "0 [8mBkEdWR1CAS9Hy9UXB2GpPe6a5HCjy5Lfo2EZ23adnc] \n", "1 [HzrMJkkN5jvD98focyivbjasDmPwPY3AkuB9aG1uAzbH,... \n", "2 [HzrMJkkN5jvD98focyivbjasDmPwPY3AkuB9aG1uAzbH] \n", "3 [HzrMJkkN5jvD98focyivbjasDmPwPY3AkuB9aG1uAzbH,... \n", "4 [HzrMJkkN5jvD98focyivbjasDmPwPY3AkuB9aG1uAzbH] \n", "5 [HzrMJkkN5jvD98focyivbjasDmPwPY3AkuB9aG1uAzbH,... \n", "6 [HzrMJkkN5jvD98focyivbjasDmPwPY3AkuB9aG1uAzbH] \n", "7 [AjJ64QbB7XnrEdC1Vroh2uiU9yjEds2HjoWSsxarYV7g,... \n", "8 [AjJ64QbB7XnrEdC1Vroh2uiU9yjEds2HjoWSsxarYV7g] \n", "9 [AjJ64QbB7XnrEdC1Vroh2uiU9yjEds2HjoWSsxarYV7g,... \n", "\n", " \n", " parsedInstruction includeSPLTransfer \n", "0 [{'programId': 'ATokenGPvbdGVxr1b2hvZbsiqW5xWH... NaN \n", "1 [{'programId': '111111111111111111111111111111... True \n", "2 [{'programId': 'A7p8451ktDCHq5yYaHczeLMYsjRsAk... NaN \n", "3 [{'programId': '111111111111111111111111111111... True \n", "4 [{'programId': 'A7p8451ktDCHq5yYaHczeLMYsjRsAk... NaN \n", "5 [{'programId': '111111111111111111111111111111... True \n", "6 [{'programId': 'ATokenGPvbdGVxr1b2hvZbsiqW5xWH... NaN \n", "7 [{'programId': '111111111111111111111111111111... True \n", "8 [{'programId': 'A7p8451ktDCHq5yYaHczeLMYsjRsAk... NaN \n", "9 [{'programId': '111111111111111111111111111111... True " ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "accounts = ['5FCSMognWSsNGjmYK9D387Zz79catdwEakdNtGf2UAJS']\n", "account_transactions = ss.get_account_transactions(accounts)\n", "account_transactions" ] }, { "cell_type": "markdown", "id": "abd13677", "metadata": {}, "source": [ "### get_account_stake" ] }, { "cell_type": "markdown", "id": "b489cff6", "metadata": {}, "source": [ "Get staking accounts of the given account(s)" ] }, { "cell_type": "code", "execution_count": 5, "id": "2e3cb212", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
6qdpJdp6L8cCSEECt4vSUbDtRH6oe7MrMY3s1iBSJHie
2dLLdNvzAWA4WZEA57SqhVajTUfVEVerZLdoHtpqAbU42NKXLftkoVmuGWnbpsX7fF3y6jzGo61Aw6V8MdwJwb7Y
voter55bmPBVG1xNHSmQ9iqzvm78Gvr8rE9wiG48MLQgJ1ywANaN
amount7717120NaN
typedelegatedinitialized
stakeAccount2dLLdNvzAWA4WZEA57SqhVajTUfVEVerZLdoHtpqAbU42NKXLftkoVmuGWnbpsX7fF3y6jzGo61Aw6V8MdwJwb7Y
staker6qdpJdp6L8cCSEECt4vSUbDtRH6oe7MrMY3s1iBSJHie6qdpJdp6L8cCSEECt4vSUbDtRH6oe7MrMY3s1iBSJHie
role[staker, withdrawer][staker]
\n", "
" ], "text/plain": [ " 6qdpJdp6L8cCSEECt4vSUbDtRH6oe7MrMY3s1iBSJHie \\\n", " 2dLLdNvzAWA4WZEA57SqhVajTUfVEVerZLdoHtpqAbU4 \n", "voter 55bmPBVG1xNHSmQ9iqzvm78Gvr8rE9wiG48MLQgJ1ywA \n", "amount 7717120 \n", "type delegated \n", "stakeAccount 2dLLdNvzAWA4WZEA57SqhVajTUfVEVerZLdoHtpqAbU4 \n", "staker 6qdpJdp6L8cCSEECt4vSUbDtRH6oe7MrMY3s1iBSJHie \n", "role [staker, withdrawer] \n", "\n", " \n", " 2NKXLftkoVmuGWnbpsX7fF3y6jzGo61Aw6V8MdwJwb7Y \n", "voter NaN \n", "amount NaN \n", "type initialized \n", "stakeAccount 2NKXLftkoVmuGWnbpsX7fF3y6jzGo61Aw6V8MdwJwb7Y \n", "staker 6qdpJdp6L8cCSEECt4vSUbDtRH6oe7MrMY3s1iBSJHie \n", "role [staker] " ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "accounts = ['6qdpJdp6L8cCSEECt4vSUbDtRH6oe7MrMY3s1iBSJHie']\n", "account_stake = ss.get_account_stake(accounts)\n", "account_stake" ] }, { "cell_type": "markdown", "id": "0c2c3590", "metadata": {}, "source": [ "### get_account_spl_transactions" ] }, { "cell_type": "markdown", "id": "1d6f5ec2", "metadata": {}, "source": [ "Return transactions that make tokenBalance change for given account(s)" ] }, { "cell_type": "code", "execution_count": 10, "id": "ff3216d3", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ...7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS
totaldata...data
0_idaddresssignaturechangeTypechangeAmountdecimalspostBalancepreBalancetokenAddress...decimalspostBalancepreBalancetokenAddresssymbolblockTimeslotfeeownerbalance
084361a52fc380bb17258972dbb2CvuuChbxzUF9enm7m8keweqhyEfh9sbPLxG7527GbAix[5otAVzzVx1WhukCS9roWjM9jiTRF2rVG6J9zgB7Tg5G2R...dec-38343960160383439601Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB...901109458362815GEcowHQW46CrEkfAdbcsdt4SV7taCetZF4sFBXN4USDCUSDC-acUSDC163855000810989564150007MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS{'amount': '0', 'decimals': 9}
184361a52fc380bb17258972dbb58CU3jaA3Vp69ksBWAmJC7JeiHsPHEuagLiruEwQdXh9Z[5otAVzzVx1WhukCS9roWjM9jiTRF2rVG6J9zgB7Tg5G2R...inc1812957832929985181031185560271mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So...601115209184EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1vUSDC163854999610989561650007MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS{'amount': '0', 'decimals': 6}
2843619ec11d80bb17258961b675CvuuChbxzUF9enm7m8keweqhyEfh9sbPLxG7527GbAix[5DiefMeGxTkYqJ6bBkZMR2rR2PEYkZLcKqNxNputNxf9C...inc-10010510093638343960110393949694Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB...900DHpoYejUDqzByb6HAdaLWF7KZvwUv2vWYDY9cTENNZuiacUSDC163854999610989561650007MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS{'amount': '0', 'decimals': 9}
3843619ec0f480bb17258961a891CoWRUXwaV36U94eFHaXcu9YCWJGoASKzz8hARPA961cs[54HqcfsRxUiuQpTz93WzGUeyWfzKoNQ5Ury515gnNXRmd...dec-104018002686010401800268EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v...911094583628150GEcowHQW46CrEkfAdbcsdt4SV7taCetZF4sFBXN4USDCUSDC-acUSDC163854999610989561650007MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS{'amount': '1109458362815', 'decimals': 9}
4843619ec0f480bb17258961a893CvuuChbxzUF9enm7m8keweqhyEfh9sbPLxG7527GbAix[54HqcfsRxUiuQpTz93WzGUeyWfzKoNQ5Ury515gnNXRmd...inc103939496946103939496940Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB...611152091840EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1vUSDC1638549779109895230100007MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS{'amount': '1115209184', 'decimals': 6}
\n", "

5 rows × 32 columns

\n", "
" ], "text/plain": [ " Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ \\\n", " total data \n", " 0 _id \n", "0 843 61a52fc380bb17258972dbb2 \n", "1 843 61a52fc380bb17258972dbb5 \n", "2 843 619ec11d80bb17258961b675 \n", "3 843 619ec0f480bb17258961a891 \n", "4 843 619ec0f480bb17258961a893 \n", "\n", " \\\n", " \n", " address \n", "0 CvuuChbxzUF9enm7m8keweqhyEfh9sbPLxG7527GbAix \n", "1 8CU3jaA3Vp69ksBWAmJC7JeiHsPHEuagLiruEwQdXh9Z \n", "2 CvuuChbxzUF9enm7m8keweqhyEfh9sbPLxG7527GbAix \n", "3 CoWRUXwaV36U94eFHaXcu9YCWJGoASKzz8hARPA961cs \n", "4 CvuuChbxzUF9enm7m8keweqhyEfh9sbPLxG7527GbAix \n", "\n", " \\\n", " \n", " signature changeType changeAmount \n", "0 [5otAVzzVx1WhukCS9roWjM9jiTRF2rVG6J9zgB7Tg5G2R... dec -383439601 \n", "1 [5otAVzzVx1WhukCS9roWjM9jiTRF2rVG6J9zgB7Tg5G2R... inc 1812957832 \n", "2 [5DiefMeGxTkYqJ6bBkZMR2rR2PEYkZLcKqNxNputNxf9C... inc -10010510093 \n", "3 [54HqcfsRxUiuQpTz93WzGUeyWfzKoNQ5Ury515gnNXRmd... dec -10401800268 \n", "4 [54HqcfsRxUiuQpTz93WzGUeyWfzKoNQ5Ury515gnNXRmd... inc 10393949694 \n", "\n", " \\\n", " \n", " decimals postBalance preBalance \n", "0 6 0 383439601 \n", "1 9 2998518103 1185560271 \n", "2 6 383439601 10393949694 \n", "3 6 0 10401800268 \n", "4 6 10393949694 0 \n", "\n", " ... \\\n", " ... \n", " tokenAddress ... \n", "0 Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB ... \n", "1 mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So ... \n", "2 Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB ... \n", "3 EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v ... \n", "4 Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB ... \n", "\n", " 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS \\\n", " data \n", " decimals postBalance preBalance \n", "0 9 0 1109458362815 \n", "1 6 0 1115209184 \n", "2 9 0 0 \n", "3 9 1109458362815 0 \n", "4 6 1115209184 0 \n", "\n", " \\\n", " \n", " tokenAddress symbol blockTime \n", "0 GEcowHQW46CrEkfAdbcsdt4SV7taCetZF4sFBXN4USDC USDC-acUSDC 1638550008 \n", "1 EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v USDC 1638549996 \n", "2 DHpoYejUDqzByb6HAdaLWF7KZvwUv2vWYDY9cTENNZui acUSDC 1638549996 \n", "3 GEcowHQW46CrEkfAdbcsdt4SV7taCetZF4sFBXN4USDC USDC-acUSDC 1638549996 \n", "4 EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v USDC 1638549779 \n", "\n", " \\\n", " \n", " slot fee owner \n", "0 109895641 5000 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS \n", "1 109895616 5000 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS \n", "2 109895616 5000 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS \n", "3 109895616 5000 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS \n", "4 109895230 10000 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS \n", "\n", " \n", " \n", " balance \n", "0 {'amount': '0', 'decimals': 9} \n", "1 {'amount': '0', 'decimals': 6} \n", "2 {'amount': '0', 'decimals': 9} \n", "3 {'amount': '1109458362815', 'decimals': 9} \n", "4 {'amount': '1115209184', 'decimals': 6} \n", "\n", "[5 rows x 32 columns]" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "accounts = ['Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ', '7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS']\n", "account_spl_transactions = ss.get_account_spl_transactions(accounts)\n", "account_spl_transactions.head()" ] }, { "cell_type": "markdown", "id": "aa361ae2", "metadata": {}, "source": [ "### get_account_sol_transactions" ] }, { "cell_type": "markdown", "id": "9190b7e1", "metadata": {}, "source": [ "Return SOL transfers for given account(s)" ] }, { "cell_type": "code", "execution_count": 11, "id": "8438449b", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ...7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS
data...data
_idsrcdstlamportblockTimeslottxHashfeestatusdecimals...srcdstlamportblockTimeslottxHashfeestatusdecimalstxNumberSolTransfer
06172e0ee5e027c1830a56c86H8sMJSCQxfKiFTCfDR3DUMLPwcRbM61LGFJ8N4dK3WjSFhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ184964685816349186101029223522X9c6eRhZeA97qEN5br4gXnMrsmTvXWQjmFbe1MameLTVB...5000Success9...4ZwSyo2oWiqb1RzhCnrqvAKyxmuJwW7dscsg6qnEXVfJ7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS1000000000016382831351094334154RWpSxiWAWijkQkD9GoqRxchcaZB8HqbGaRffMRXbZbPht...5000Success91
1617184335e027c18302f4094H8sMJSCQxfKiFTCfDR3DUMLPwcRbM61LGFJ8N4dK3WjSFhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ246523598216348293251027488553CakodWbdHYiog29bBtYAE8PsUbnM5ZAZYVSpp73aoLX3g...5000Success9...4ZwSyo2oWiqb1RzhCnrqvAKyxmuJwW7dscsg6qnEXVfJ7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS1000000000016375981231081799115HWfFYfPp77TjWepHoZ3NVsmUF9xGispoBPu6BNmGAxuza...5000Success91
2615679ed5e027c1830d1c65bFhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ65GJB6cfYgFnVRuGtWoE3PEHeDJt2nd1FwUQgVmxB4MG20392801633012174990979074LtH9ewJwPP491bQvPYzooZaVzw25qquK6vi5iRRS5ykdA...5000Success9...7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaSH8oMhzkrpA63MH548xQd1MLHLUBAJJXPJPZoAhr1j8ny600000000016371888731073964404S2tJqfFCRdzWh35NoyRdehCRJwkETTo3hq1gWpJNUev8S...5000Success91
36155d53d5e027c1830758304Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ65GJB6cfYgFnVRuGtWoE3PEHeDJt2nd1FwUQgVmxB4MG570020392801632871654988371002Lwqok6ShGHKVkpv1KCpUAdEyDQL4yn8M8Y8N4qmWqfUo3...5000Success9...7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaSH8oMhzkrpA63MH548xQd1MLHLUBAJJXPJPZoAhr1j8ny3178000000016371888081073963013ypF2dAAyCEy7Ap1ucDdyCVm1xbMsrujWiwV1wQQMgeKGW...5000Success91
46144ab262cb5c76649f2bd17Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ65GJB6cfYgFnVRuGtWoE3PEHeDJt2nd1FwUQgVmxB4MG2039280163189019196965191op3vZtRqTxo1Z8YKw3pYrzkgpM2fD5rCiR21UhdbFJNicH...5000Success9...4ZwSyo2oWiqb1RzhCnrqvAKyxmuJwW7dscsg6qnEXVfJ7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS100000000001636994573107033173E6ScKmDJTEda9g7oSoan5XyVeadJwU87exTLKVPaunPeBX...5000Success91
\n", "

5 rows × 22 columns

\n", "
" ], "text/plain": [ " Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ \\\n", " data \n", " _id \n", "0 6172e0ee5e027c1830a56c86 \n", "1 617184335e027c18302f4094 \n", "2 615679ed5e027c1830d1c65b \n", "3 6155d53d5e027c1830758304 \n", "4 6144ab262cb5c76649f2bd17 \n", "\n", " \\\n", " \n", " src \n", "0 H8sMJSCQxfKiFTCfDR3DUMLPwcRbM61LGFJ8N4dK3WjS \n", "1 H8sMJSCQxfKiFTCfDR3DUMLPwcRbM61LGFJ8N4dK3WjS \n", "2 Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ \n", "3 Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ \n", "4 Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ \n", "\n", " \\\n", " \n", " dst lamport blockTime \n", "0 Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ 1849646858 1634918610 \n", "1 Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ 2465235982 1634829325 \n", "2 65GJB6cfYgFnVRuGtWoE3PEHeDJt2nd1FwUQgVmxB4MG 2039280 1633012174 \n", "3 65GJB6cfYgFnVRuGtWoE3PEHeDJt2nd1FwUQgVmxB4MG 57002039280 1632871654 \n", "4 65GJB6cfYgFnVRuGtWoE3PEHeDJt2nd1FwUQgVmxB4MG 2039280 1631890191 \n", "\n", " \\\n", " \n", " slot txHash fee \n", "0 102922352 2X9c6eRhZeA97qEN5br4gXnMrsmTvXWQjmFbe1MameLTVB... 5000 \n", "1 102748855 3CakodWbdHYiog29bBtYAE8PsUbnM5ZAZYVSpp73aoLX3g... 5000 \n", "2 99097907 4LtH9ewJwPP491bQvPYzooZaVzw25qquK6vi5iRRS5ykdA... 5000 \n", "3 98837100 2Lwqok6ShGHKVkpv1KCpUAdEyDQL4yn8M8Y8N4qmWqfUo3... 5000 \n", "4 96965191 op3vZtRqTxo1Z8YKw3pYrzkgpM2fD5rCiR21UhdbFJNicH... 5000 \n", "\n", " ... 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS \\\n", " ... data \n", " status decimals ... src \n", "0 Success 9 ... 4ZwSyo2oWiqb1RzhCnrqvAKyxmuJwW7dscsg6qnEXVfJ \n", "1 Success 9 ... 4ZwSyo2oWiqb1RzhCnrqvAKyxmuJwW7dscsg6qnEXVfJ \n", "2 Success 9 ... 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS \n", "3 Success 9 ... 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS \n", "4 Success 9 ... 4ZwSyo2oWiqb1RzhCnrqvAKyxmuJwW7dscsg6qnEXVfJ \n", "\n", " \\\n", " \n", " dst lamport blockTime \n", "0 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS 10000000000 1638283135 \n", "1 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS 10000000000 1637598123 \n", "2 H8oMhzkrpA63MH548xQd1MLHLUBAJJXPJPZoAhr1j8ny 6000000000 1637188873 \n", "3 H8oMhzkrpA63MH548xQd1MLHLUBAJJXPJPZoAhr1j8ny 31780000000 1637188808 \n", "4 7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS 10000000000 1636994573 \n", "\n", " \\\n", " \n", " slot txHash fee \n", "0 109433415 4RWpSxiWAWijkQkD9GoqRxchcaZB8HqbGaRffMRXbZbPht... 5000 \n", "1 108179911 5HWfFYfPp77TjWepHoZ3NVsmUF9xGispoBPu6BNmGAxuza... 5000 \n", "2 107396440 4S2tJqfFCRdzWh35NoyRdehCRJwkETTo3hq1gWpJNUev8S... 5000 \n", "3 107396301 3ypF2dAAyCEy7Ap1ucDdyCVm1xbMsrujWiwV1wQQMgeKGW... 5000 \n", "4 107033173 E6ScKmDJTEda9g7oSoan5XyVeadJwU87exTLKVPaunPeBX... 5000 \n", "\n", " \n", " \n", " status decimals txNumberSolTransfer \n", "0 Success 9 1 \n", "1 Success 9 1 \n", "2 Success 9 1 \n", "3 Success 9 1 \n", "4 Success 9 1 \n", "\n", "[5 rows x 22 columns]" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "accounts = ['Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ', '7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS']\n", "account_sol_transactions = ss.get_account_sol_transactions(accounts)\n", "account_sol_transactions.head()" ] }, { "cell_type": "markdown", "id": "8ec1cd74", "metadata": {}, "source": [ "### get_account_export_transactions" ] }, { "cell_type": "markdown", "id": "9b00d645", "metadata": {}, "source": [ "Export transactions to CSV style string\n", "\n", "Allowed types: tokenchange | soltransfer | all" ] }, { "cell_type": "code", "execution_count": 12, "id": "036bfd94", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'Type, Txhash, BlockTime Unix, B'" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "accounts = ['Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ', '7MwQuB8vsCosYiqY4NCBDiECgsv5aFDYP3Zd5zBT6oaS']\n", "account_export_transactions = ss.get_account_export_transactions(accounts, type_in='all',from_time=0,to_time=1634918610)\n", "# Trust me this is a CSV style string but if you print the whole thing, your screen will get full\n", "# Recommend: write string to a file and open with an Excel like program.\n", "account_export_transactions[0][:100]" ] }, { "cell_type": "markdown", "id": "926543db", "metadata": {}, "source": [ "### get_account" ] }, { "cell_type": "markdown", "id": "f30ee307", "metadata": {}, "source": [ "Return overall account(s) information, including program account, NFT metadata information" ] }, { "cell_type": "code", "execution_count": 6, "id": "6d0eb9c5", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQhz4sZFVC1MccN3WaSZ8YjHcZLewLw2JL7t1RfaRa4Pe
lamports3844058511836946368111
ownerProgram1111111111111111111111111111111111111111111111111111111111111111
typesystem_accountsystem_account
rentEpoch264265
accountFhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQhz4sZFVC1MccN3WaSZ8YjHcZLewLw2JL7t1RfaRa4Pe
\n", "
" ], "text/plain": [ " Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ \\\n", "lamports 384405851 \n", "ownerProgram 11111111111111111111111111111111 \n", "type system_account \n", "rentEpoch 264 \n", "account Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ \n", "\n", " hz4sZFVC1MccN3WaSZ8YjHcZLewLw2JL7t1RfaRa4Pe \n", "lamports 1836946368111 \n", "ownerProgram 11111111111111111111111111111111 \n", "type system_account \n", "rentEpoch 265 \n", "account hz4sZFVC1MccN3WaSZ8YjHcZLewLw2JL7t1RfaRa4Pe " ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "accounts = ['Fhhq7AtgMsWge7oBMMWkqaF4boMLJ6Utcmc2X1oEsqJQ', 'hz4sZFVC1MccN3WaSZ8YjHcZLewLw2JL7t1RfaRa4Pe']\n", "accounts = ss.get_account(accounts)\n", "accounts" ] }, { "cell_type": "markdown", "id": "982f7826", "metadata": {}, "source": [ "## Tokens" ] }, { "cell_type": "markdown", "id": "c0745b0d", "metadata": {}, "source": [ "### get_token_holders" ] }, { "cell_type": "markdown", "id": "3d3414c8", "metadata": {}, "source": [ "Return top token holders for given token(s)" ] }, { "cell_type": "code", "execution_count": 14, "id": "7962c21e", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1
datatotal
addressamountdecimalsownerrank0
0HTwd3VaDQphZgh2x7wqE2Qdndo4TT5C8fpvhKFcNh1Rt4624078338877268x2uay8UgrLiX8AAYyF6AkK9z91nNtN6aLwfqPkf6TAQ139492
1DAKRKS2F1Bk3tqRVVvDKUnVtC5LSJ52JVUqwQ6aNUKL7282905174030606u6PJ8DtQuPFnfmwHbGFULQ4u4EgjDiyYKjVEsynXq2w239492
2DrJTQqNZqNCf2HDLpYg9zRCMRwnhZEVQuGjeaWtX6CA7156031677762996ATkEV1nEkdp7zgaGpzFCsJ5WAyejcJbxqzGhQpfcDW4S339492
386hiF77ktrdVFU9xFqxsYChRirgs9KCvQDD9g4jT64bJ109916829443796DdZR6zRFiUt4S5mg7AV1uKB2z1f1WzcNYCaTEEWPAuby439492
4E9JJDxJLj8jpexcT9RthxJy6XNoisBLfvweC5p1n53JX820344932844962qThW12GKGmtxNLiEBrx2c6p3s16MVDrQL78M5JVK5H8539492
\n", "
" ], "text/plain": [ " Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1 \\\n", " data \n", " address amount decimals \n", "0 HTwd3VaDQphZgh2x7wqE2Qdndo4TT5C8fpvhKFcNh1Rt 46240783388772 6 \n", "1 DAKRKS2F1Bk3tqRVVvDKUnVtC5LSJ52JVUqwQ6aNUKL7 28290517403060 6 \n", "2 DrJTQqNZqNCf2HDLpYg9zRCMRwnhZEVQuGjeaWtX6CA7 15603167776299 6 \n", "3 86hiF77ktrdVFU9xFqxsYChRirgs9KCvQDD9g4jT64bJ 10991682944379 6 \n", "4 E9JJDxJLj8jpexcT9RthxJy6XNoisBLfvweC5p1n53JX 8203449328449 6 \n", "\n", " \n", " total \n", " owner rank 0 \n", "0 8x2uay8UgrLiX8AAYyF6AkK9z91nNtN6aLwfqPkf6TAQ 1 39492 \n", "1 u6PJ8DtQuPFnfmwHbGFULQ4u4EgjDiyYKjVEsynXq2w 2 39492 \n", "2 ATkEV1nEkdp7zgaGpzFCsJ5WAyejcJbxqzGhQpfcDW4S 3 39492 \n", "3 DdZR6zRFiUt4S5mg7AV1uKB2z1f1WzcNYCaTEEWPAuby 4 39492 \n", "4 2qThW12GKGmtxNLiEBrx2c6p3s16MVDrQL78M5JVK5H8 5 39492 " ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tokens = ['Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1']\n", "token_holders = ss.get_token_holders(tokens, limit=50)\n", "token_holders.head()" ] }, { "cell_type": "markdown", "id": "427d3ea2", "metadata": {}, "source": [ "### get_token_meta" ] }, { "cell_type": "markdown", "id": "658beba7", "metadata": {}, "source": [ "Return metadata of given token(s)" ] }, { "cell_type": "code", "execution_count": 15, "id": "8ce3b294", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1
symbolSBR
nameSaber Protocol Token
iconhttps://raw.githubusercontent.com/solana-labs/...
websitehttps://saber.so
twitterhttps://twitter.com/saber_hq
decimals6
coingeckoIdsaber
holder39492
\n", "
" ], "text/plain": [ " Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1\n", "symbol SBR\n", "name Saber Protocol Token\n", "icon https://raw.githubusercontent.com/solana-labs/...\n", "website https://saber.so\n", "twitter https://twitter.com/saber_hq\n", "decimals 6\n", "coingeckoId saber\n", "holder 39492" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tokens = ['Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1']\n", "token_meta = ss.get_token_meta(tokens)\n", "token_meta" ] }, { "cell_type": "markdown", "id": "02548683", "metadata": {}, "source": [ "### get_token_list" ] }, { "cell_type": "markdown", "id": "6e68b5d3", "metadata": {}, "source": [ "Returns DataFrame of tokens\n", "\n", "sort_by (default market_cap): \n", "- market_cap\n", "- volume\n", "- holder\n", "- price\n", "- price_change_24h\n", "- price_change_7d\n", "- price_change_14d\n", "- price_change_30d\n", "- price_change_60d\n", "- price_change_200d\n", "- price_change_1y\n", "\n", "ascending (default True):\n", "\n", "limit (default 10, max 50):\n", "\n", "offset" ] }, { "cell_type": "code", "execution_count": 16, "id": "0d4de18d", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
mintAddresstokenSymboltokenNamedecimalsiconextensionswebsitetwittertokenHoldermarketCapRanksupplyholderpriceUstmarketCapFDvolumecoingeckoInfotag
02ctKUDkGBnVykt31AhMPhHvAQWJvoNGbLh7aRidjtAqvwPOLS_v1PolkastarterToken (Wormhole v1)9https://raw.githubusercontent.com/solana-labs/...{'coingeckoID': 'polkastarter', 'address': '0x...True329{'amount': '5000000', 'decimals': 9, 'uiAmount...13.160000e+000.015800{'volumeUsd': 36664205, 'volume': 0}{'marketCapRank': 263, 'coingeckoRank': 653, '...[wrapped, wormhole]
13UeKTABxz9XexDtyKq646rSQvx8GVpKNwfMoKKfxsTsFwBBTC_v1Binance Wrapped BTC (Wormhole v1)8https://raw.githubusercontent.com/solana-labs/...{'coingeckoID': 'binance-wrapped-btc', 'addres...True328{'amount': '100', 'decimals': 8, 'uiAmount': 1...14.910500e+040.049105{'volumeUsd': 105060, 'volume': 0}{'marketCapRank': None, 'coingeckoRank': 5454,...[wrapped, wormhole]
2Avz2fmevhhu87WYtWQCFj9UjKRjF9Z9QWwN2ih9yF95GCOMPWrapped Compound (Sollet)6https://raw.githubusercontent.com/solana-labs/...{'coingeckoID': 'compound-coin', 'bridgeContra...True327{'amount': '1000000000000', 'decimals': 6, 'ui...181.205000e-070.120500{'volumeUsd': 310.47, 'volume': 0}{'marketCapRank': None, 'coingeckoRank': 4616,...[wrapped-sollet, ethereum]
3De2bU64vsXKU9jq4bCjeDxNRGPn8nr3euaTK8jBYmD3JrenFILrenFIL9https://raw.githubusercontent.com/solana-labs/...{'coingeckoID': 'renfil', 'coingeckoId': 'renf...https://renproject.io/True326{'amount': '24806459', 'decimals': 9, 'uiAmoun...13.893000e+010.965715{'volumeUsd': 0, 'volume': 0}{'marketCapRank': None, 'coingeckoRank': 4037,...NaN
4Gc9rR2dUHfuYCJ8rU1Ye9fr8JoZZt9ZrfmXitQRLsxRWwMIR_v1Wrapped MIR Token (Wormhole v1)9https://raw.githubusercontent.com/solana-labs/...{'coingeckoID': 'mirror-protocol', 'address': ...True325{'amount': '1000000000', 'decimals': 9, 'uiAmo...12.160000e+002.160000{'volumeUsd': 28388035, 'volume': 0}{'marketCapRank': 235, 'coingeckoRank': 692, '...[wrapped, wormhole]
\n", "
" ], "text/plain": [ " mintAddress tokenSymbol \\\n", "0 2ctKUDkGBnVykt31AhMPhHvAQWJvoNGbLh7aRidjtAqv wPOLS_v1 \n", "1 3UeKTABxz9XexDtyKq646rSQvx8GVpKNwfMoKKfxsTsF wBBTC_v1 \n", "2 Avz2fmevhhu87WYtWQCFj9UjKRjF9Z9QWwN2ih9yF95G COMP \n", "3 De2bU64vsXKU9jq4bCjeDxNRGPn8nr3euaTK8jBYmD3J renFIL \n", "4 Gc9rR2dUHfuYCJ8rU1Ye9fr8JoZZt9ZrfmXitQRLsxRW wMIR_v1 \n", "\n", " tokenName decimals \\\n", "0 PolkastarterToken (Wormhole v1) 9 \n", "1 Binance Wrapped BTC (Wormhole v1) 8 \n", "2 Wrapped Compound (Sollet) 6 \n", "3 renFIL 9 \n", "4 Wrapped MIR Token (Wormhole v1) 9 \n", "\n", " icon \\\n", "0 https://raw.githubusercontent.com/solana-labs/... \n", "1 https://raw.githubusercontent.com/solana-labs/... \n", "2 https://raw.githubusercontent.com/solana-labs/... \n", "3 https://raw.githubusercontent.com/solana-labs/... \n", "4 https://raw.githubusercontent.com/solana-labs/... \n", "\n", " extensions website \\\n", "0 {'coingeckoID': 'polkastarter', 'address': '0x... \n", "1 {'coingeckoID': 'binance-wrapped-btc', 'addres... \n", "2 {'coingeckoID': 'compound-coin', 'bridgeContra... \n", "3 {'coingeckoID': 'renfil', 'coingeckoId': 'renf... https://renproject.io/ \n", "4 {'coingeckoID': 'mirror-protocol', 'address': ... \n", "\n", " twitter tokenHolder marketCapRank \\\n", "0 True 329 \n", "1 True 328 \n", "2 True 327 \n", "3 True 326 \n", "4 True 325 \n", "\n", " supply holder priceUst \\\n", "0 {'amount': '5000000', 'decimals': 9, 'uiAmount... 1 3.160000e+00 \n", "1 {'amount': '100', 'decimals': 8, 'uiAmount': 1... 1 4.910500e+04 \n", "2 {'amount': '1000000000000', 'decimals': 6, 'ui... 18 1.205000e-07 \n", "3 {'amount': '24806459', 'decimals': 9, 'uiAmoun... 1 3.893000e+01 \n", "4 {'amount': '1000000000', 'decimals': 9, 'uiAmo... 1 2.160000e+00 \n", "\n", " marketCapFD volume \\\n", "0 0.015800 {'volumeUsd': 36664205, 'volume': 0} \n", "1 0.049105 {'volumeUsd': 105060, 'volume': 0} \n", "2 0.120500 {'volumeUsd': 310.47, 'volume': 0} \n", "3 0.965715 {'volumeUsd': 0, 'volume': 0} \n", "4 2.160000 {'volumeUsd': 28388035, 'volume': 0} \n", "\n", " coingeckoInfo \\\n", "0 {'marketCapRank': 263, 'coingeckoRank': 653, '... \n", "1 {'marketCapRank': None, 'coingeckoRank': 5454,... \n", "2 {'marketCapRank': None, 'coingeckoRank': 4616,... \n", "3 {'marketCapRank': None, 'coingeckoRank': 4037,... \n", "4 {'marketCapRank': 235, 'coingeckoRank': 692, '... \n", "\n", " tag \n", "0 [wrapped, wormhole] \n", "1 [wrapped, wormhole] \n", "2 [wrapped-sollet, ethereum] \n", "3 NaN \n", "4 [wrapped, wormhole] " ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "token_list = ss.get_token_list(limit=50)\n", "token_list.head()" ] }, { "cell_type": "markdown", "id": "46328243", "metadata": {}, "source": [ "### get_market_info" ] }, { "cell_type": "markdown", "id": "fc2dc8a0", "metadata": {}, "source": [ "Return market information of the given token(s)" ] }, { "cell_type": "code", "execution_count": 17, "id": "f7703e30", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD12FPyTwcZLUg1MDrwsyoP4D6s1tM7hAkHYRjkNb5w6Pxk
priceUsdt5.457900e-024.135590e+03
volumeUsdt1.000595e+062.677430e+10
\n", "
" ], "text/plain": [ " Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1 \\\n", "priceUsdt 5.457900e-02 \n", "volumeUsdt 1.000595e+06 \n", "\n", " 2FPyTwcZLUg1MDrwsyoP4D6s1tM7hAkHYRjkNb5w6Pxk \n", "priceUsdt 4.135590e+03 \n", "volumeUsdt 2.677430e+10 " ] }, "execution_count": 17, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tokens = ['Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1', '2FPyTwcZLUg1MDrwsyoP4D6s1tM7hAkHYRjkNb5w6Pxk']\n", "market_info = ss.get_market_info(tokens)\n", "market_info" ] }, { "cell_type": "markdown", "id": "5838a289", "metadata": {}, "source": [ "### get_chain_info" ] }, { "cell_type": "markdown", "id": "1ce903b3", "metadata": {}, "source": [ "Return blockchain overall information" ] }, { "cell_type": "code", "execution_count": 18, "id": "2ea16ec8", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
chain_info
blockHeight99400275
currentEpoch255
absoluteSlot110340277
transactionCount43621199246
\n", "
" ], "text/plain": [ " chain_info\n", "blockHeight 99400275\n", "currentEpoch 255\n", "absoluteSlot 110340277\n", "transactionCount 43621199246" ] }, "execution_count": 18, "metadata": {}, "output_type": "execute_result" } ], "source": [ "chain_info = ss.get_chain_info()\n", "chain_info" ] }, { "cell_type": "code", "execution_count": null, "id": "d673ad72", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.9" } }, "nbformat": 4, "nbformat_minor": 5 }